The Course Completion file only contains learners that have met the requirements for the successful completion of a course as set out in the approved course or outline.
Checking type B learners for inclusion
SDR administrators can ensure that the correct records are returned in the Course Completion file, so that they do not receive validation errors from the MoE. The logic checks the types of learners to determine whether they should be included.
When an enrolment is identified as Type B and the source of funding is not in 06, 07, 08, 11 or 21, then include the enrolment if the learner has a Type D enrolment with a date range spanning that of the year in which the start date of the Type B enrolment falls (for example: if the Type B start date is in 2016, if the learner enrolled is enrolled on a Type D enrolment at any point in 2016, they should be included).
Completion code
The completion code, which is output in the Course Completion file, for values of 2 and 3, is based on the progress code associated with the grade for the course outcome. This provides the benefit of not having to ensure that an enrolment is manually advanced to the correct progress code.
Populating file entries
The Course Completion file entries are populated as follows:
- If no attainments are linked to an enrolment, or if the linked attainment's grade is null, the SDR completion code mapped to the enrolment progress code is reported in the Course Completion file
- If an attainment is linked to an enrolment where a grade exists against the attainment and the following applies:
- The grade has been mapped to a SDR completion code in the GRADING_SCHEME_GRADES table
- The Include in SDR flag against the attainment is set
Then the SDR completion code linked to the grade is reported in the Course Completion file:
- If there are two or more course outcomes linked to an enrolment, the Course Completion file will include all of them
- If a new outcome is linked to a course that ran in a previous SDR reporting year, then if this changes the completion status of an enrolment, this record is reported in the Course Completion file
When an enrolment has an active progress code but no attainments with grades, the system reports the completion code linked to the progress code of the enrolment in the Course Completion file.
You can add an attainment to such enrolments and give them grades that map to SDR completion codes in the GRADING_SCHEME_GRADES table. The system then reports the completion code linked to the grade in the Course Completion file, rather than that of the enrolment.
You can migrate enrolment data into ebs from another system. Where more than one course outcome links to such enrolments, and where these have grades that map to a SDR completion code in the GRADING_SCHEME_GRADES table, the system reports the completion codes linked to all the attainment's grades in the Course Completion file, rather than those of the enrolments.
If this causes a SDR file validation error when submitting the return, you need to correct any errors that are included.
You can change the effective completion code for an enrolment or an attainment linked to an enrolment that was reported in a previous SDR reporting year. The system reports this in the Course Completion file even though the enrolment would not otherwise have been reported.